package com.lsx.logisticscore.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.lsx.logisticscore.entity.Product;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;
import java.util.Map;

@Mapper
public interface ProductMapper extends BaseMapper<Product> {

    Page<Product> selectProductByCondition(Page<Product> page, String category);

    List<Map<String, Object>> get7dayInSum(String local);

    List<Map<String, Object>> get7dayOutSum();

    List<Map<String, Object>> getTodayOutByCategory(String local);

    List<Map<String, Object>> getTodayOutTop5(String local);

    List<String> selectProductCategory();

    Integer selectSum();

    Double selectValue();

    Map<String, Object> selectHottest();

    List<Map<String, Object>> selectCountByType();

    List<Map<String, Object>> selectCountByPrice();

}
